/*
 Navicat Premium Data Transfer

 Source Server         : soyorin
 Source Server Type    : MySQL
 Source Server Version : 90300
 Source Host           : localhost:3306
 Source Schema         : soyorin

 Target Server Type    : MySQL
 Target Server Version : 90300
 File Encoding         : 65001

 Date: 08/06/2025 12:24:02
*/

use soyorin;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for chat
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `owner_order_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of chat
-- ----------------------------
BEGIN;
INSERT INTO `chat` (`id`, `create_time`, `update_time`, `owner_order_id`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1);
INSERT INTO `chat` (`id`, `create_time`, `update_time`, `owner_order_id`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2);
COMMIT;

-- ----------------------------
-- Table structure for chat_item
-- ----------------------------
DROP TABLE IF EXISTS `chat_item`;
CREATE TABLE `chat_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rela_chat_id` int NOT NULL,
  `send_user_id` int NOT NULL,
  `is_picture` tinyint unsigned NOT NULL,
  `content` varchar(1024) NOT NULL,
  `reply_chat_item_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of chat_item
-- ----------------------------
BEGIN;
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 3, 0, '请问我的披萨做好了吗？', NULL);
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 7, 0, '您好，您的披萨正在制作中，大约还需要10分钟', 1);
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (3, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 3, 0, '好的，谢谢！', NULL);
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (4, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 9, 0, '您好，我是配送员，已经取到您的餐品，正在配送途中', NULL);
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (5, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 3, 0, '收到，辛苦了！', 4);
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (6, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 4, 0, '可以加辣吗？', NULL);
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (7, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 8, 0, '当然可以，我们会为您调制更辣的锅底', 1);
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (8, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 4, 0, '太好了，谢谢！', NULL);
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (9, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 10, 0, '您好，我是骑手小王，已到达您的楼下', NULL);
INSERT INTO `chat_item` (`id`, `create_time`, `update_time`, `rela_chat_id`, `send_user_id`, `is_picture`, `content`, `reply_chat_item_id`) VALUES (10, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 4, 0, '马上下来取餐', 4);
COMMIT;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rela_shop_id` int NOT NULL,
  `rela_goods_category_id` int DEFAULT NULL,
  `name` char(64) NOT NULL,
  `description` varchar(256) DEFAULT NULL,
  `price` int NOT NULL,
  `image_address` varchar(512) DEFAULT NULL,
  `is_on` tinyint unsigned NOT NULL DEFAULT '1',
  `monthly_sale_count` int DEFAULT NULL,
  `tag` varchar(32) DEFAULT NULL,
  `inner_index` int DEFAULT '10',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of goods
-- ----------------------------
BEGIN;
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 1, '巨无霸', '经典双层牛肉汉堡，配生菜、洋葱、酸黄瓜', 2200, '/goods/bigmac.jpg', 1, 850, '招牌', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 1, '麦香鸡', '酥脆炸鸡配新鲜生菜和美味酱料', 1800, '/goods/mcchicken.jpg', 1, 650, '热销', 2);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (3, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 2, '薯条(大)', '金黄酥脆的马铃薯条', 1200, '/goods/fries_large.jpg', 1, 1200, '必点', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (4, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 2, '麦乐鸡(10块)', '嫩滑多汁的鸡块配蘸酱', 1600, '/goods/nuggets_10.jpg', 1, 800, '儿童最爱', 2);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (5, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 3, '可口可乐(中)', '经典可乐，冰爽解腻', 800, '/goods/coke_medium.jpg', 1, 1500, '经典', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (6, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 4, '苹果派', '香甜苹果馅配酥脆外皮', 600, '/goods/apple_pie.jpg', 1, 400, '甜品', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (7, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 5, '原味鸡(2块)', '秘制11种香料调味的炸鸡', 1800, '/goods/original_chicken.jpg', 1, 900, '招牌', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (8, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 5, '香辣鸡翅(2只)', '香辣调味，外酥内嫩', 1500, '/goods/spicy_wings.jpg', 1, 750, '香辣', 2);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (9, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 6, '香辣鸡腿堡', '香辣鸡腿配新鲜蔬菜', 2000, '/goods/spicy_burger.jpg', 1, 600, '热销', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (10, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 7, '上校鸡块(6块)', '一口一个的美味鸡块', 1400, '/goods/popcorn_chicken.jpg', 1, 550, '小食', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (11, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 8, '百事可乐(中)', '百事可乐，年轻的选择', 800, '/goods/pepsi_medium.jpg', 1, 800, '饮料', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (12, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 9, '至尊披萨(9寸)', '丰富配料，满足味蕾', 4800, '/goods/supreme_pizza.jpg', 1, 300, '招牌', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (13, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 9, '玛格丽特披萨(9寸)', '经典意式，番茄芝士香草', 3600, '/goods/margherita_pizza.jpg', 1, 250, '经典', 2);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (14, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 10, '意式肉酱面', '传统意式肉酱配意大利面', 2800, '/goods/spaghetti_bolognese.jpg', 1, 200, '意面', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (15, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 11, '凯撒沙拉', '新鲜蔬菜配凯撒酱汁', 2200, '/goods/caesar_salad.jpg', 1, 150, '健康', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (16, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 12, '柠檬汽水', '清爽柠檬味汽水', 1200, '/goods/lemon_soda.jpg', 1, 180, '饮料', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (17, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 13, '番茄锅底', '新鲜番茄熬制，酸甜开胃', 2800, '/goods/tomato_hotpot.jpg', 1, 200, '经典', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (18, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 13, '麻辣锅底', '四川正宗麻辣，香辣过瘾', 3200, '/goods/spicy_hotpot.jpg', 1, 180, '招牌', 2);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (19, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 14, '精品肥牛', '优质肥牛，肉质鲜嫩', 4800, '/goods/premium_beef.jpg', 1, 160, '精品', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (20, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 14, '手切羊肉', '新鲜羊肉现切，无膻味', 5200, '/goods/fresh_lamb.jpg', 1, 120, '新鲜', 2);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (21, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 15, '娃娃菜', '嫩绿娃娃菜，清爽解腻', 1200, '/goods/baby_cabbage.jpg', 1, 200, '蔬菜', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (22, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 16, '酸梅汤', '传统酸梅汤，生津止渴', 1500, '/goods/sour_plum_drink.jpg', 1, 100, '饮料', 1);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (24, '2015-07-18 09:12:26', '2022-09-19 00:11:37', 36, 875, 'Hasegawa Hina', 'z4AyQQhFZl', 158, '343 Qingshuihe 1st Rd, Luohu District', 0, 629, '8k6Xfqw7wx', 311);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (25, '2016-04-27 04:25:43', '2024-05-05 17:28:45', 60, 432, 'Koo Wai Yee', 'Pz5bcSDu2P', 150, '756 Narborough Rd', 1, 676, 'yBfO36zT3A', 430);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (26, '2000-01-20 03:31:58', '2010-05-28 06:28:51', 93, 211, 'Yuen Wing Kuen', '34u84LZwMW', 807, '761 Lodge Ln, Toxteth', 1, 450, 'JQn0g7vK5Z', 21);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (27, '2003-05-17 23:05:35', '2020-04-18 05:16:01', 88, 257, 'Nakano Sakura', 'RX4RwoMow5', 725, '13-3-20 Toyohira 3 Jo, Toyohira Ward', 1, 559, 'q8gOKlneoJ', 485);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (28, '2018-03-30 16:17:33', '2005-01-11 11:48:12', 12, 26, 'Hsuan Chung Yin', 'uVlnp85pCw', 820, '760 Wyngate Dr', 1, 838, 'gb2AVvfqoF', 912);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (29, '2010-01-05 04:33:53', '2021-03-04 07:56:52', 42, 838, 'Nakano Mitsuki', 'nZWHkH20F1', 528, '410 Lodge Ln, Toxteth', 1, 511, '5Zl9LhkveD', 517);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (30, '2013-03-09 22:23:37', '2019-05-07 19:21:05', 22, 893, 'Yung Ka Ming', '1f8uxyNnA8', 454, '2-3-18 Yoyogi, Shibuya-ku', 0, 143, '8X2j6P5Qwp', 995);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (31, '2005-11-23 10:17:20', '2018-05-23 03:27:10', 30, 792, 'Tang Kar Yan', '7lpKncnkzb', 472, '249 State Street', 0, 768, 'ccBAnx9otq', 575);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (32, '2001-08-28 00:50:29', '2003-09-30 04:33:21', 85, 273, 'Ono Yuto', 'rZHRWFb6Q2', 552, '1-7-8 Omido, Higashiosaka', 0, 149, 'VIOaDg0yCJ', 113);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (33, '2009-12-06 10:31:19', '2004-05-29 15:11:13', 53, 904, 'Yamamoto Yuito', 'P9QfGeySN1', 916, '103 Daxin S Rd, Daxin Shangquan, Tianhe Qu', 1, 329, 'xnXPru16wv', 901);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (34, '2005-09-24 11:32:22', '2011-09-08 08:41:00', 95, 107, 'Tao Ziyi', 'VaMmgaxfOF', 366, '792 Xue Yuan Yi Xiang, Longgang', 0, 809, 'nAjnMBVreh', 333);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (35, '2021-07-04 06:42:37', '2001-06-28 04:48:49', 76, 584, 'Lee Wai Lam', '5izWc476Hv', 980, '846 Abingdon Rd, Cumnor', 0, 1, 'Scezp1BWz2', 309);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (36, '2007-08-10 13:38:11', '2010-11-07 04:46:40', 52, 865, 'Yuen Wing Sze', 'ElCMrJkBBH', 956, '249 Hongqiao Rd., Xu Hui District', 1, 877, 'g5dq3e14AN', 605);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (37, '2000-02-11 13:06:15', '2002-12-03 12:37:05', 53, 684, 'Ueno Airi', 'Vor7G3Q7Gc', 80, '655 Tianbei 1st Rd, Luohu District', 1, 20, 'aFNzZvwMfV', 960);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (38, '2024-01-17 13:36:11', '2021-08-12 06:49:04', 62, 324, 'Zeng Shihan', 'uejborwwyK', 274, '2-1-13 Tenjinnomori, Nishinari Ward', 0, 233, '2eoxhgc8x7', 634);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (39, '2020-07-22 11:32:58', '2010-09-16 08:02:33', 81, 138, 'Fong Kwok Kuen', '3HyWMUQoH5', 435, '353 New Street', 1, 520, 'R9u6Lf2zom', 694);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (40, '2009-03-09 02:43:54', '2013-06-13 01:22:33', 91, 838, 'Wan Ka Fai', '7nIkTS8mpx', 349, '352 2nd Zhongshan Road, Yuexiu District', 0, 583, 'kDAt0BuEbL', 47);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (41, '2005-04-28 06:39:30', '2011-07-24 06:56:33', 58, 690, 'Xie Rui', 'eGenIjJY1L', 241, '1-1-5 Deshiro, Nishinari Ward', 1, 410, 'z0rniaNWut', 594);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (42, '2015-11-19 02:20:26', '2016-04-11 04:20:40', 25, 194, 'Sean Spencer', 'hyKxHAqMcY', 165, '666 East Wangfujing Street, Dongcheng District ', 0, 194, 'nbuM06zsdK', 876);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (43, '2003-11-19 09:33:55', '2018-02-13 07:31:04', 65, 631, 'Ueno Tsubasa', 'sVO0OhmLIo', 153, '703 Rush Street', 1, 139, '35eQeNOA1d', 388);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (44, '2000-02-10 18:30:25', '2015-07-01 22:52:57', 24, 347, 'Wu Rui', 'GEhtu3vUqf', 626, '3-15-1 Ginza, Chuo-ku', 1, 934, 'V1YvouMuRG', 93);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (45, '2019-09-03 09:17:07', '2008-02-21 13:27:50', 37, 963, 'Louis Sanders', 'gkcWXTBfnz', 322, '432 Lefeng 6th Rd', 0, 417, 'pToX9XIY97', 472);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (46, '2015-11-14 02:16:24', '2023-01-23 19:30:33', 36, 829, 'Patricia Chavez', '5K5tYLNSar', 583, '795 Jianxiang Rd, Pudong', 1, 803, 'HY9FjbkidO', 557);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (47, '2006-04-07 16:45:00', '2008-11-25 15:32:35', 75, 594, 'Chan Cho Yee', 'cpbgJL319z', 833, '74 Stephenson Street', 1, 40, '8wfWe5G0Hw', 902);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (48, '2018-01-05 19:18:21', '2001-10-12 20:10:29', 63, 574, 'Miyazaki Kaito', 'z5cxEumtQp', 888, '489 Flatbush Ave', 0, 643, '8jnqOMbdfQ', 200);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (49, '2005-02-07 11:24:44', '2003-02-01 03:22:43', 20, 839, 'Loui Chun Yu', 'lhYsfu61xG', 151, '13-3-9 Toyohira 3 Jo, Toyohira Ward', 0, 155, 'bajmnUYQ48', 224);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (50, '2014-07-04 16:20:21', '2007-06-20 14:00:35', 59, 596, 'Hashimoto Mitsuki', 'isVsScOJRM', 113, '641 3rd Section Hongxing Road, Jinjiang District', 0, 360, 'W4cXsiCYit', 679);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (51, '2000-08-20 05:01:35', '2016-11-08 03:30:37', 35, 973, 'Morita Daisuke', 'fiPrBqwdor', 352, '5-2-15 Kikusui 3 Jo, Shiroishi Ward', 1, 1, 'C974YaNdHL', 352);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (52, '2009-07-10 20:11:29', '2018-12-13 16:52:30', 89, 592, 'Takeda Shino', 'W2UIs0h7f6', 173, 'No. 580, Shuangqing Rd, Chenghua District', 1, 342, 'HwsZH8eVzj', 580);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (53, '2007-12-17 21:18:48', '2023-06-22 03:00:28', 39, 490, 'Liu Ziyi', '6npBKXjElc', 466, '4-9-2 Kamihigashi, Hirano Ward', 1, 71, 'D5PDgJmCxS', 613);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (54, '2018-10-08 00:53:28', '2013-11-18 19:36:04', 70, 42, 'Morita Daichi', 'znK2DPH3fY', 560, '1-6-14, Marunouchi, Chiyoda-ku', 0, 915, 'CU9ER6GvXG', 900);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (55, '2021-06-19 03:08:57', '2020-03-04 14:17:23', 99, 130, 'Lau Tsz Ching', '8HOEYssarZ', 550, '469 3rd Section Hongxing Road, Jinjiang District', 0, 560, 'UsT2CfpVJz', 557);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (56, '2010-04-05 17:57:15', '2024-03-19 04:33:16', 40, 821, 'Shi Xiaoming', 'cZTfzf6c1N', 659, '166 Broadway', 0, 744, 'td78pvBfwo', 648);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (57, '2014-10-30 09:05:14', '2021-11-23 02:27:24', 46, 337, 'Watanabe Riku', 'qTNqs7X3nW', 261, '1-7-12 Saidaiji Akodacho', 1, 346, '4Oq31yeAuR', 699);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (58, '2001-04-21 16:36:18', '2022-11-23 18:45:53', 85, 921, 'Yuan Xiaoming', 'RWkUi7Llfo', 886, '771 Shanhu Rd', 0, 718, 'Cf18STYfSf', 815);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (59, '2015-09-26 23:36:38', '2007-03-06 19:33:49', 35, 555, 'Hara Kenta', 'qLw3HaWeBD', 913, '770 West Houston Street', 0, 998, 'HPWs6MDc6d', 544);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (60, '2007-02-04 12:32:53', '2011-09-17 05:22:19', 46, 248, 'Catherine Murray', 'wgeR8KC0z8', 978, '5-4-12 Kikusui 3 Jo, Shiroishi Ward,', 1, 174, 'fW7jiof4kc', 465);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (61, '2023-08-07 06:49:53', '2023-12-03 04:50:14', 78, 248, 'Hirano Hikaru', 'n0j80Dsfje', 82, '472 East Cooke Road', 1, 30, 'BML40rxy5W', 163);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (62, '2001-05-18 03:39:10', '2011-11-11 18:40:33', 38, 806, 'Tao Ching Wan', 'jrxITf3DVG', 37, '633 Xiaoping E Rd, Baiyun ', 0, 678, 'GRS3SkFkJz', 987);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (63, '2012-03-20 14:57:58', '2018-02-14 07:27:37', 71, 241, 'Lam Ka Ling', 'qKLUA5TuaI', 628, '904 The Pavilion, Lammas Field, Driftway', 1, 570, 'wRDIyz2pD6', 895);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (64, '2009-07-05 22:59:39', '2013-02-22 04:58:39', 45, 386, 'Ueno Sara', 'JixAW45lk5', 455, '929 Tianhe Road, Tianhe District', 1, 799, 'FJK8cGWCqU', 895);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (65, '2016-01-09 16:30:31', '2005-04-09 06:15:04', 99, 248, 'Meng Tin Lok', 'd4dKhscItS', 966, '1-1-20 Deshiro, Nishinari Ward', 1, 330, '3xUuopxWkP', 959);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (66, '2011-08-25 20:36:51', '2013-04-01 16:43:59', 64, 4, 'Lai Wai Man', 'SK0dUDm7Qu', 682, '8 4-20 Kawagishicho, Mizuho Ward', 0, 720, 'yo1AHFeUQc', 913);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (67, '2003-10-26 07:16:02', '2005-01-08 01:09:39', 63, 813, 'Norma Cox', 'oaOGx1PspX', 986, '665 49/50 Strand, Charing Cross', 1, 856, 'CLuEoJWKhk', 388);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (68, '2008-08-24 17:49:51', '2003-10-05 02:55:50', 45, 195, 'Frank Payne', 'IcaZpPLyEC', 303, '3-27-10 Higashitanabe, Higashisumiyoshi Ward', 0, 258, 'dTxeXvF9uP', 70);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (69, '2004-01-20 12:42:40', '2022-11-13 13:28:14', 62, 111, 'Norman Gomez', 'pCND4n2Ngo', 447, '13-3-12 Toyohira 3 Jo, Toyohira Ward', 1, 51, 'tKAoDlYXFo', 350);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (70, '2019-11-03 07:29:19', '2005-10-30 16:28:21', 68, 696, 'Peng Zhennan', 'jnUFNWHLd1', 494, '310 3rd Section Hongxing Road, Jinjiang District', 1, 413, 'BWQgmBm7Pl', 271);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (71, '2022-04-28 18:58:47', '2007-03-15 12:14:38', 20, 779, 'Tong Chieh Lun', 'MQRH78UD2A', 125, '749 Tianhe Road, Tianhe District', 1, 37, 'zQekThB8v8', 842);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (72, '2002-05-22 02:30:27', '2000-02-17 11:01:57', 64, 275, 'Shimada Daichi', 'l2rcKcVOne', 689, '210 Qingshuihe 1st Rd, Luohu District', 0, 200, 's5GaONMER7', 479);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (73, '2014-06-09 01:54:34', '2017-04-01 01:57:17', 93, 583, 'Cao Lu', 'hdaUecmrv4', 650, '878 Fern Street', 1, 386, '3QnoygDkM6', 375);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (74, '2002-11-17 16:30:45', '2004-10-24 01:54:01', 16, 970, 'Pak Kar Yan', 'iNVEEdUvOu', 528, '765 Rush Street', 0, 221, 'uLDXjDZA16', 733);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (75, '2013-11-16 05:18:58', '2011-10-26 16:51:11', 55, 738, 'Chin Kwok Wing', 'DPpWwoRstk', 468, '364 Lodge Ln, Toxteth', 1, 17, 'JdJUtS0hgJ', 591);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (76, '2003-11-12 22:50:19', '2015-08-21 11:29:57', 47, 585, 'Paula King', 'VLnJPLo5jI', 221, '133 Kengmei 15th Alley', 1, 44, 'gmqxkPjXWk', 260);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (77, '2020-02-18 10:26:08', '2016-11-30 06:06:48', 81, 431, 'Watanabe Mai', 'UixQuh588a', 891, '19 3-803 Kusunokiajima, Kita Ward', 0, 521, 'xxscS3A6sT', 42);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (78, '2017-03-07 01:45:16', '2007-04-04 19:45:03', 27, 137, 'Daniel Guzman', 'OXFTDayoU3', 10, '13-3-12 Toyohira 3 Jo, Toyohira Ward', 0, 396, 'eTHfEUIIWw', 726);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (79, '2021-10-02 19:18:55', '2002-01-29 22:09:48', 85, 343, 'Hazel Clark', 'HrFR8Z4koR', 50, '277 The Pavilion, Lammas Field, Driftway', 0, 365, 'QnwLrFj3wB', 849);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (80, '2014-07-24 22:16:12', '2006-10-14 02:06:20', 68, 832, 'Yip Cho Yee', '6YWUiQ3tgT', 309, '2-1-16 Tenjinnomori, Nishinari Ward', 0, 685, 'VaEtt4HcbA', 650);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (81, '2010-02-04 20:24:07', '2001-08-25 20:22:57', 74, 275, 'Billy Allen', '641k8JXce4', 91, '110 Flatbush Ave', 1, 589, 'FCZ7abdO3K', 96);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (82, '2005-08-26 17:20:53', '2020-07-07 22:50:15', 49, 212, 'Jiang Jiehong', 'N2YzvKJJgk', 724, '9 1-1715 Sekohigashi, Moriyama Ward', 0, 959, 'xRea0Mb0vJ', 839);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (83, '2014-08-03 09:37:27', '2014-09-22 05:08:17', 16, 917, 'Shi Jialun', 'oy4SWc7s76', 635, '990 Flatbush Ave', 1, 675, 'o27jbLHsxQ', 761);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (84, '2013-07-01 05:37:12', '2021-05-13 15:59:37', 71, 326, 'Kim Schmidt', 'M4Vs09mJIy', 67, '258 North Michigan Ave', 1, 204, 'a6Az1rueXP', 92);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (85, '2012-06-26 17:29:05', '2015-12-04 03:39:05', 71, 294, 'Maruyama Mio', 'jGOvdE99Ud', 751, '920 State Street', 0, 604, 'eOymgPZKhg', 397);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (86, '2000-09-30 06:11:11', '2010-11-05 05:37:08', 31, 809, 'Harada Kazuma', '3KHYnK7anu', 993, '11 Flatbush Ave', 1, 173, '2Lq1lxxoYi', 575);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (87, '2007-06-03 03:55:34', '2018-04-18 00:23:26', 81, 127, 'Tamura Shino', 'o8vFyDR3Gi', 429, '458 Xiaoping E Rd, Baiyun ', 1, 127, 'AGjVIngsEy', 894);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (88, '2004-08-01 12:48:34', '2022-09-08 19:23:33', 35, 922, 'Ng Sai Wing', 'dWfPvuxKBC', 814, '1-6-14, Marunouchi, Chiyoda-ku', 1, 760, 'dfpVEyntY1', 164);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (89, '2023-08-11 00:11:12', '2013-09-19 10:30:53', 98, 12, 'Fang Ziyi', 'qnNXyZ5lVE', 394, '492 Xue Yuan Yi Xiang, Longgang', 0, 154, 'Zh8P82X3XR', 249);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (90, '2002-06-18 16:46:35', '2010-11-06 03:26:09', 33, 277, 'Heung Suk Yee', 'ltM7QezAn1', 581, '620 Tremont Road', 1, 1000, 'eWFszcQV4Z', 255);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (91, '2009-04-09 10:54:54', '2024-09-03 16:17:52', 99, 545, 'Qiu Zhiyuan', 'hlOOnfWvUI', 684, '1-7-2 Saidaiji Akodacho', 1, 805, 'FIOvvih2OA', 869);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (92, '2004-01-26 15:04:19', '2000-04-09 17:08:03', 38, 833, 'Nakamura Mitsuki', 'VJ67RRSKsR', 526, '819 Pollen Street', 0, 141, 'xYCupKUoty', 647);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (93, '2017-08-09 17:06:46', '2004-06-26 07:40:07', 55, 908, 'Johnny Harrison', 'tzRCbrpS9X', 513, '4-9-6 Kamihigashi, Hirano Ward', 1, 196, 'aDWNQRKWWp', 360);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (94, '2014-06-22 08:49:03', '2016-09-08 21:46:53', 36, 712, 'Hu Jialun', 'f4TBXmBAwu', 691, '825 68 Qinghe Middle St, Haidian District', 0, 895, 'OIHpmT809n', 305);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (95, '2004-07-10 10:09:59', '2015-04-14 08:25:55', 58, 193, 'Nakano Kenta', '5oo84pauio', 87, '863 4th Section  Renmin South Road, Jinjiang District', 1, 815, 'b3DopD9awE', 980);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (96, '2011-01-17 14:59:15', '2005-09-26 09:25:05', 75, 430, 'Antonio Thomas', 'Fxj1J5wuFA', 616, '315 North Michigan Ave', 1, 102, 'ly0K5qFaZN', 590);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (97, '2006-04-29 06:16:04', '2008-05-23 09:03:00', 68, 348, 'Eva Reynolds', 'yYgsaejKcV', 720, '510 Redfern St', 1, 717, 'n6rO2z58uZ', 962);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (98, '2020-08-09 07:08:03', '2012-08-13 00:15:22', 29, 627, 'Sheh Lai Yan', '6MNis5YGd6', 394, '873 West Houston Street', 0, 609, 'CfwCBKir3e', 915);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (99, '2020-02-09 19:12:51', '2021-05-31 13:46:39', 78, 154, 'Brandon Chavez', 'OnChCkffjC', 620, '39 Pollen Street', 0, 652, 'lA8mkwWMk3', 437);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (100, '2018-08-17 21:12:59', '2006-08-03 21:22:27', 29, 3, 'Nicholas Peterson', 'yTT4e17QSd', 836, '322 Flatbush Ave', 1, 776, 'GVy5Na2GFU', 164);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (101, '2011-12-16 15:54:50', '2005-10-28 09:43:26', 10, 134, 'Martin Porter', 'e8ovrP8Qwa', 572, '1-6-12, Marunouchi, Chiyoda-ku', 1, 264, 'b3Rh0GEnzq', 898);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (102, '2016-05-10 00:48:33', '2009-08-22 21:45:36', 84, 276, 'Ti Wai Han', 'cvH1w6ToRS', 431, '194 49/50 Strand, Charing Cross', 0, 841, '4PGeAS63oq', 4);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (103, '2012-07-06 08:23:53', '2012-03-02 22:30:18', 88, 279, 'Hasegawa Riku', 'EvzHffw1nG', 97, '66 Pollen Street', 0, 398, 'pSbWntqfmN', 972);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (104, '2001-06-26 12:42:22', '2012-09-27 04:51:49', 29, 768, 'Lillian Chen', 'ZOs6XRCABQ', 272, '552 Maddox Street', 0, 830, 'vXFY8fNNoH', 997);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (105, '2016-08-14 17:12:41', '2016-09-03 01:16:03', 62, 480, 'Anthony Henry', '1mneJW6vZY', 937, '986 68 Qinghe Middle St, Haidian District', 0, 272, '8OYpboe5zD', 34);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (106, '2006-09-19 21:35:47', '2016-03-15 04:30:56', 66, 68, 'Kimura Akina', 'sega96fIYN', 789, '396 Fern Street', 0, 4, '6LNHpvvPCY', 10);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (107, '2012-05-19 22:53:40', '2007-02-06 10:12:44', 64, 941, 'Dai Lai Yan', 'Sxu31Nsf61', 752, '811 Zhongshan 5th Rd, Zimaling Shangquan', 0, 566, 'MOrpO2A45E', 574);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (108, '2021-03-24 01:01:02', '2020-08-31 19:55:07', 57, 307, 'Cho Ka Ling', 'hki4lVKOPo', 512, '807 Stephenson Street', 1, 882, 'nZqOJwQ2X1', 254);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (109, '2003-11-05 10:41:24', '2007-02-15 08:27:58', 90, 572, 'Sugawara Mitsuki', 'BWEQF11svV', 40, '3 3-803 Kusunokiajima, Kita Ward', 1, 118, 'yC1hlGMPoI', 943);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (110, '2003-10-09 04:29:34', '2004-07-19 19:31:10', 15, 907, 'Zhong Zhiyuan', 'wOA0s6fiIz', 428, '5-2-5 Kikusui 3 Jo, Shiroishi Ward', 1, 928, 'vTo60ByqQ2', 17);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (111, '2024-05-12 16:55:53', '2006-04-11 14:19:30', 34, 92, 'Roger Chen', '1ewT2qpfcM', 19, '582 Central Avenue', 0, 201, 'J5jeIltmKD', 432);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (112, '2015-12-11 19:12:02', '2007-04-19 18:31:38', 34, 349, 'Wu Rui', '2FdZshnOZM', 355, '154 Shennan Ave, Futian District', 0, 608, '73zaJ3GIPP', 395);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (113, '2019-08-19 14:30:58', '2019-06-06 05:55:39', 80, 354, 'Fujiwara Eita', 'T2ihkpKqEQ', 875, '3 1-1715 Sekohigashi, Moriyama Ward', 0, 554, 'FG0QKJtJQ4', 174);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (114, '2018-03-30 10:05:34', '2006-08-18 05:26:08', 89, 883, 'Cui Xiuying', 'VMThQswbUf', 73, '751 Narborough Rd', 1, 622, 'KgTNDNV213', 575);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (115, '2023-02-07 02:35:49', '2021-12-02 20:31:49', 26, 665, 'Hui Wing Sze', 'MdU1NbWlf5', 901, '321 W Ring Rd, Buji Town, Longgang', 1, 78, 'Me9uOxWXRw', 638);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (116, '2000-11-16 22:33:33', '2002-02-10 09:16:55', 57, 650, 'He Jialun', 'u4OjivS152', 415, '5-2-8 Kikusui 3 Jo, Shiroishi Ward', 0, 87, 'tU3o2YIC6A', 476);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (117, '2004-10-29 00:18:32', '2011-04-01 18:05:26', 56, 369, 'Sugiyama Momoka', '69kHavslTW', 749, '307 Mosley St', 1, 422, 'ge8azMubeO', 420);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (118, '2016-08-17 08:31:55', '2001-11-05 14:46:53', 19, 814, 'Pan Zhennan', '9wdJYV70Gv', 377, '417 Kengmei 15th Alley', 1, 38, 'VMkeYHY7nu', 975);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (119, '2016-08-21 17:56:54', '2018-07-06 00:35:33', 43, 135, 'Duan Lu', '5Uobf2w0rn', 68, '4-9-17 Kamihigashi, Hirano Ward', 0, 887, 'TvcpKvCYy6', 647);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (120, '2019-09-10 05:16:43', '2021-03-23 17:31:11', 76, 938, 'Meng Rui', 'doyMvfWnjN', 95, '251 State Street', 0, 955, 't7kp4zaWZ5', 834);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (121, '2019-03-21 11:52:32', '2010-07-23 13:12:28', 29, 301, 'Chow Wing Suen', 'DyDmAoYtLp', 597, '494 39 William IV St, Charing Cross', 0, 607, 'p1vrIdzKz4', 335);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (122, '2005-09-12 18:51:26', '2015-08-18 22:00:32', 59, 374, 'Sarah Nelson', 'sZlmxEEIwT', 532, '517 Mosley St', 1, 457, 'yj3lU2HMF4', 526);
INSERT INTO `goods` (`id`, `create_time`, `update_time`, `rela_shop_id`, `rela_goods_category_id`, `name`, `description`, `price`, `image_address`, `is_on`, `monthly_sale_count`, `tag`, `inner_index`) VALUES (123, '2012-11-04 03:26:25', '2020-03-27 23:36:58', 69, 245, 'Sugiyama Akina', 'eSz5wzXwK8', 856, '950 Narborough Rd', 1, 262, 'nK8jK0dvWj', 707);
COMMIT;

-- ----------------------------
-- Table structure for goods_category
-- ----------------------------
DROP TABLE IF EXISTS `goods_category`;
CREATE TABLE `goods_category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rela_shop_id` int NOT NULL,
  `inner_index` int DEFAULT '10',
  `name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of goods_category
-- ----------------------------
BEGIN;
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 1, '汉堡类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 2, '小食类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (3, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 3, '饮料类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (4, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 4, '甜品类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (5, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 1, '炸鸡类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (6, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 2, '汉堡类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (7, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 3, '小食类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (8, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 4, '饮料类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (9, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 1, '披萨类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (10, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 2, '意面类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (11, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 3, '沙拉类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (12, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 4, '饮料类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (13, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 1, '锅底类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (14, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 2, '肉类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (15, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 3, '蔬菜类');
INSERT INTO `goods_category` (`id`, `create_time`, `update_time`, `rela_shop_id`, `inner_index`, `name`) VALUES (16, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 4, '饮料类');
COMMIT;

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rela_c_user_id` int NOT NULL,
  `rela_b_user_id` int NOT NULL,
  `rela_r_user_id` int NOT NULL,
  `is_b_define` tinyint unsigned NOT NULL DEFAULT '0',
  `is_r_define` tinyint unsigned NOT NULL DEFAULT '0',
  `is_cooked` tinyint unsigned NOT NULL DEFAULT '0',
  `is_arrive_b` tinyint unsigned NOT NULL DEFAULT '0',
  `is_arrive_c` tinyint unsigned NOT NULL DEFAULT '0',
  `is_rate` tinyint unsigned NOT NULL DEFAULT '0',
  `c_position_x` double NOT NULL,
  `c_position_y` double NOT NULL,
  `b_position_x` double NOT NULL,
  `b_position_y` double NOT NULL,
  `r_position_x` double NOT NULL,
  `r_position_y` double NOT NULL,
  `start_time` datetime DEFAULT NULL,
  `cooked_time` datetime DEFAULT NULL,
  `arrive_b_time` datetime DEFAULT NULL,
  `arrive_c_time` datetime DEFAULT NULL,
  `rating` int DEFAULT '500',
  `rating_content` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of order
-- ----------------------------
BEGIN;
INSERT INTO `order` (`id`, `create_time`, `update_time`, `rela_c_user_id`, `rela_b_user_id`, `rela_r_user_id`, `is_b_define`, `is_r_define`, `is_cooked`, `is_arrive_b`, `is_arrive_c`, `is_rate`, `c_position_x`, `c_position_y`, `b_position_x`, `b_position_y`, `r_position_x`, `r_position_y`, `start_time`, `cooked_time`, `arrive_b_time`, `arrive_c_time`, `rating`, `rating_content`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 7, 9, 1, 1, 1, 1, 1, 1, 116.377048, 39.906901, 116.378048, 39.907901, 116.377548, 39.907401, '2024-01-15 12:30:00', '2024-01-15 12:45:00', '2024-01-15 12:50:00', '2024-01-15 13:05:00', 450, '披萨很好吃，送餐及时，服务态度很好！');
INSERT INTO `order` (`id`, `create_time`, `update_time`, `rela_c_user_id`, `rela_b_user_id`, `rela_r_user_id`, `is_b_define`, `is_r_define`, `is_cooked`, `is_arrive_b`, `is_arrive_c`, `is_rate`, `c_position_x`, `c_position_y`, `b_position_x`, `b_position_y`, `r_position_x`, `r_position_y`, `start_time`, `cooked_time`, `arrive_b_time`, `arrive_c_time`, `rating`, `rating_content`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 8, 10, 1, 1, 1, 1, 1, 1, 116.417592, 39.917723, 116.418592, 39.918723, 116.418092, 39.918223, '2024-01-14 19:00:00', '2024-01-14 19:20:00', '2024-01-14 19:25:00', '2024-01-14 19:45:00', 500, '海底捞的服务真的没话说，食材新鲜，强烈推荐！');
COMMIT;

-- ----------------------------
-- Table structure for pack
-- ----------------------------
DROP TABLE IF EXISTS `pack`;
CREATE TABLE `pack` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rela_user_id` int NOT NULL,
  `rela_shop_id` int NOT NULL,
  `dis_price` int DEFAULT '0',
  `dis_tag` char(32) DEFAULT NULL,
  `sum_price` int DEFAULT '0',
  `is_define` tinyint unsigned NOT NULL DEFAULT '0',
  `is_pay` tinyint unsigned NOT NULL DEFAULT '0',
  `owner_order_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of pack
-- ----------------------------
BEGIN;
INSERT INTO `pack` (`id`, `create_time`, `update_time`, `rela_user_id`, `rela_shop_id`, `dis_price`, `dis_tag`, `sum_price`, `is_define`, `is_pay`, `owner_order_id`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 1, 200, '满20减2', 3800, 0, 0, NULL);
INSERT INTO `pack` (`id`, `create_time`, `update_time`, `rela_user_id`, `rela_shop_id`, `dis_price`, `dis_tag`, `sum_price`, `is_define`, `is_pay`, `owner_order_id`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 2, 0, '', 4200, 0, 0, NULL);
INSERT INTO `pack` (`id`, `create_time`, `update_time`, `rela_user_id`, `rela_shop_id`, `dis_price`, `dis_tag`, `sum_price`, `is_define`, `is_pay`, `owner_order_id`) VALUES (3, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 3, 500, '首单优惠', 6500, 1, 1, 1);
INSERT INTO `pack` (`id`, `create_time`, `update_time`, `rela_user_id`, `rela_shop_id`, `dis_price`, `dis_tag`, `sum_price`, `is_define`, `is_pay`, `owner_order_id`) VALUES (4, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 4, 1000, '会员折扣', 13700, 1, 1, 2);
COMMIT;

-- ----------------------------
-- Table structure for pack_item
-- ----------------------------
DROP TABLE IF EXISTS `pack_item`;
CREATE TABLE `pack_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rela_pack_id` int NOT NULL,
  `owner_goods_id` int NOT NULL,
  `count` int DEFAULT '0',
  `price` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of pack_item
-- ----------------------------
BEGIN;
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 1, 1, 2200);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 3, 1, 1200);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (3, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 5, 1, 800);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (4, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 7, 1, 1800);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (5, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 9, 1, 2000);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (6, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 11, 1, 800);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (7, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 12, 1, 4800);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (8, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 16, 1, 1200);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (9, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 18, 1, 3200);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (10, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 19, 2, 4800);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (11, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 21, 1, 1200);
INSERT INTO `pack_item` (`id`, `create_time`, `update_time`, `rela_pack_id`, `owner_goods_id`, `count`, `price`) VALUES (12, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 22, 1, 1500);
COMMIT;

-- ----------------------------
-- Table structure for shop
-- ----------------------------
DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rela_user_id` int NOT NULL,
  `name` char(64) NOT NULL,
  `image` varchar(256) DEFAULT '/food001.jpg',
  `description` char(128) DEFAULT NULL,
  `logo_address` varchar(512) DEFAULT NULL,
  `address` varchar(256) DEFAULT NULL,
  `position_x` double DEFAULT NULL,
  `position_y` double DEFAULT NULL,
  `phone` char(32) DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `min_order_amount` int DEFAULT '0',
  `delivery_fee` int DEFAULT '500',
  `av_rating` double DEFAULT NULL,
  `av_amount` int DEFAULT NULL,
  `monthly_order_count` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of shop
-- ----------------------------
BEGIN;
INSERT INTO `shop` (`id`, `create_time`, `update_time`, `rela_user_id`, `name`, `image`, `description`, `logo_address`, `address`, `position_x`, `position_y`, `phone`, `start_time`, `end_time`, `min_order_amount`, `delivery_fee`, `av_rating`, `av_amount`, `monthly_order_count`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 5, '麦当劳(国贸店)', '/shops/mcdonald_guomao.jpg', '全球知名快餐连锁，提供汉堡、薯条、饮料等美食', '北京市朝阳区建国门外大街甲6号SK大厦1层', '北京市朝阳区建国门外大街甲6号', 116.459654, 39.918723, '010-85295888', '06:00:00', '23:00:00', 2000, 600, 4.5, 3500, 1250);
INSERT INTO `shop` (`id`, `create_time`, `update_time`, `rela_user_id`, `name`, `image`, `description`, `logo_address`, `address`, `position_x`, `position_y`, `phone`, `start_time`, `end_time`, `min_order_amount`, `delivery_fee`, `av_rating`, `av_amount`, `monthly_order_count`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 6, '肯德基(中关村店)', '/shops/kfc_zhongguancun.jpg', '美式快餐专家，炸鸡汉堡的不二选择', '北京市海淀区中关村大街15号', '北京市海淀区中关村大街15号', 116.316419, 39.984634, '010-62551234', '06:30:00', '22:30:00', 1500, 500, 4.3, 2800, 980);
INSERT INTO `shop` (`id`, `create_time`, `update_time`, `rela_user_id`, `name`, `image`, `description`, `logo_address`, `address`, `position_x`, `position_y`, `phone`, `start_time`, `end_time`, `min_order_amount`, `delivery_fee`, `av_rating`, `av_amount`, `monthly_order_count`) VALUES (3, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 7, '必胜客(西单店)', '/shops/pizza_xidan.jpg', '意式休闲餐厅，披萨意面的美味天堂', '北京市西城区西单北大街176号', '北京市西城区西单北大街176号', 116.378048, 39.907901, '010-66018888', '10:00:00', '22:00:00', 3000, 800, 4.2, 6500, 650);
INSERT INTO `shop` (`id`, `create_time`, `update_time`, `rela_user_id`, `name`, `image`, `description`, `logo_address`, `address`, `position_x`, `position_y`, `phone`, `start_time`, `end_time`, `min_order_amount`, `delivery_fee`, `av_rating`, `av_amount`, `monthly_order_count`) VALUES (4, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 8, '海底捞(王府井店)', '/shops/hotpot_wangfujing.jpg', '火锅界的服务标杆，新鲜食材贴心服务', '北京市东城区王府井大街301号', '北京市东城区王府井大街301号', 116.418592, 39.918723, '010-65258888', '11:00:00', '02:00:00', 8000, 1000, 4.8, 15000, 420);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `account` char(64) NOT NULL,
  `password` varchar(128) NOT NULL,
  `bind_email` char(64) DEFAULT NULL,
  `bind_phone` char(32) DEFAULT NULL,
  `role` enum('c','b','r') NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  `avatar` varchar(256) DEFAULT '/boy.png',
  PRIMARY KEY (`id`),
  UNIQUE KEY `account` (`account`),
  UNIQUE KEY `bind_email` (`bind_email`),
  UNIQUE KEY `bind_phone` (`bind_phone`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'customer01', 'password123', 'zhang.wei@email.com', '13800138001', 'c', '张伟', '/avatars/customer01.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'customer02', 'password123', 'li.na@email.com', '13800138002', 'c', '李娜', '/avatars/customer02.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (3, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'customer03', 'password123', 'wang.ming@email.com', '13800138003', 'c', '王明', '/avatars/customer03.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (4, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'customer04', 'password123', 'liu.fang@email.com', '13800138004', 'c', '刘芳', '/avatars/customer04.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (5, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'business01', 'password123', 'mcdonald@business.com', '13900139001', 'b', '麦当劳店长', '/avatars/business01.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (6, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'business02', 'password123', 'kfc@business.com', '13900139002', 'b', '肯德基店长', '/avatars/business02.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (7, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'business03', 'password123', 'pizza@business.com', '13900139003', 'b', '必胜客店长', '/avatars/business03.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (8, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'business04', 'password123', 'hotpot@business.com', '13900139004', 'b', '海底捞店长', '/avatars/business04.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (9, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'rider01', 'password123', 'rider01@delivery.com', '13700137001', 'r', '张骑手', '/avatars/rider01.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (10, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'rider02', 'password123', 'rider02@delivery.com', '13700137002', 'r', '李骑手', '/avatars/rider02.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (11, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 'rider03', 'password123', 'rider03@delivery.com', '13700137003', 'r', '王骑手', '/avatars/rider03.jpg');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (13, '2017-10-08 09:14:46', '2006-07-22 14:10:51', 'x6jtKcJoGL', 'ccj7aP5F3n', 'shinoh@icloud.com', '(151) 596 8643', 'c', 'Hashimoto Shino', 'LbCdrAWW55');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (14, '2024-04-18 02:07:05', '2013-07-24 05:25:47', 'vuFM2RAlTY', 'pctPPsiUEK', 'mhazuki@outlook.com', '(20) 7039 0765', 'r', 'Miura Hazuki', '4mSYiPhZis');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (15, '2016-11-16 18:38:04', '2006-12-20 10:25:26', 'wyBdE11tn2', 'LGVM21h5Lm', 'howardbailey5@outlook.com', '21-3850-6415', 'b', 'Howard Bailey', 'tUVannRBt2');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (16, '2017-04-03 07:08:39', '2014-10-26 10:47:35', 'thbml1dCkV', 'jRFc7ENgzw', 'sun11@gmail.com', '760-781-1540', 'r', 'Sun Yuning', 'Hzwd0vcLmk');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (17, '2016-08-04 11:27:45', '2019-06-21 05:26:57', 'KOP3yYWono', 'DiiUeg8unR', 'nomura9@outlook.com', '7482 743837', 'b', 'Nomura Hina', 'd3R3oRFZgG');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (18, '2017-04-21 23:08:38', '2010-06-04 16:44:40', '44hEZBC92t', 'uV8EqnZmMG', 'wua1983@gmail.com', '70-3042-4512', 'c', 'Wu Anqi', 'h9VKk0h2A0');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (19, '2004-09-17 14:37:48', '2025-02-06 06:07:23', '3GJVp6WWzj', '79zjoO0eqt', 'hashhana62@yahoo.com', '70-1307-2040', 'r', 'Hashimoto Hana', 'Jc2Z1qAP8d');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (20, '2022-01-11 12:04:14', '2002-08-01 01:05:12', 'BQTkmm5KLf', 'CWA732xeDm', 'tlm@gmail.com', '755-176-3114', 'r', 'Mo Tin Lok', 'F48MITMVeI');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (21, '2020-04-19 06:11:47', '2025-02-17 12:53:57', 'eaUWPGH3BG', '97hqh2JJr5', 'masonherbe3@icloud.com', '70-3203-4053', 'b', 'Herbert Mason', '4TR3PXdcf5');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (22, '2010-04-30 08:27:00', '2011-04-27 00:59:38', 'zvFABtyOn9', 'B9BjkQvHAI', 'daichiwatan@icloud.com', '212-977-0193', 'c', 'Watanabe Daichi', 'CcQm7W9tzo');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (23, '2016-01-27 09:21:35', '2000-02-05 19:24:47', 'r4FdJCfB0A', '467nQxZlrb', 'cyc@gmail.com', '70-0503-9738', 'c', 'Chow Chung Yin', 'jIor3b9xCR');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (24, '2019-10-17 04:56:32', '2022-08-06 02:00:27', '8oFNBSFpga', 'XkhElpOE0T', 'kellysimpson@icloud.com', '74-324-8180', 'b', 'Kelly Simpson', 'YxZeeVIKXZ');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (25, '2018-03-20 15:50:58', '2015-10-11 00:31:28', 'MRpMrnrboV', 'Yy0W21KA4z', 'kmwong@gmail.com', '(121) 307 1185', 'b', 'Wong Ka Man', 'MxeCjT7o5N');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (26, '2002-12-28 18:03:00', '2017-11-04 16:18:12', 'YehbO7htdI', 'jZBtvVKPlR', 'yulingwu68@icloud.com', '760-4427-9260', 'c', 'Wu Yu Ling', 'ml51CbrEXY');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (27, '2014-10-02 10:13:09', '2024-03-08 16:58:29', 'Xg3xDYcapd', 'dOjYCKKAGG', 'che701@outlook.com', '769-912-4948', 'b', 'Che Suk Yee', 'lMCn4iyjgZ');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (28, '2015-02-05 03:09:24', '2019-05-28 20:27:59', '4j17CiXX8K', 'lxPXoEigEc', 'yqiu414@gmail.com', '330-142-5379', 'b', 'Qiu Yunxi', 'd9R6A6x4D4');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (29, '2012-03-04 15:24:29', '2001-08-09 06:56:06', 'pCAFZcJ47j', 'BLe5L7kKxz', 'mic1029@hotmail.com', '10-587-1813', 'b', 'Cheung Ming', '25iUJjIdQo');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (30, '2009-02-21 07:18:20', '2011-08-13 04:44:32', 'pO3JUQdpPn', 'FTPLs6dazV', 'frederick66@mail.com', '838-761-7486', 'r', 'Frederick Flores', 'i8zQZFoABe');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (31, '2014-01-31 04:25:16', '2011-06-12 23:55:02', 'lH1h7GvB9L', 'lo4mbamT1h', 'kusumwing917@hotmail.com', '5988 915133', 'r', 'Ku Sum Wing', '1Jc40PTqKX');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (32, '2008-10-30 12:25:24', '2016-04-10 12:19:33', 'xO3C8yzkKR', 'FZ2omaUpjy', 'xia64@outlook.com', '312-932-8901', 'r', 'Xia Lu', 'DfQY9hGXHV');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (33, '2005-03-29 02:44:08', '2006-03-30 07:48:21', 'hx7QnExMW2', 'YWWqDP6FDU', 'chungyin16@mail.com', '21-6369-5384', 'b', 'Yuen Chung Yin', 'UDV8nFgeda');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (34, '2022-06-14 21:41:11', '2016-03-17 10:14:17', 'uKudVszK5n', 'iJbnhOIWJB', 'shimizuakina@outlook.com', '74-657-7931', 'c', 'Shimizu Akina', 'GbJYiTmguA');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (35, '2014-11-02 14:21:02', '2010-05-15 16:53:02', 'pTrac4RcEV', 'hFzoKEno4N', 'tclok827@mail.com', '212-784-5931', 'r', 'Lok Tsz Ching', 'PNhmaewPXs');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (36, '2021-05-04 12:32:46', '2025-05-25 14:39:13', 'zOuMyXmXea', 'm6sPUeL9YD', 'danngardner1979@mail.com', '90-0096-0114', 'c', 'Danny Gardner', '8LipYmwU9C');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (37, '2016-10-29 21:12:35', '2021-11-16 19:03:00', 'boWxchsq6S', '0AhroEa6l7', 'kwokyinm1223@icloud.com', '760-2673-4436', 'r', 'Miu Kwok Yin', 'xyp9n4gWeN');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (38, '2016-01-21 04:39:51', '2010-04-26 07:56:58', 'PzKRKfgHtg', 'ghft7M5hhe', 'otsuka95@yahoo.com', '194-5870-7156', 'c', 'Otsuka Takuya', 'MX7qznuvHE');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (39, '2022-03-18 16:18:51', '2008-03-16 12:50:06', 'sBAvvnHX2Q', 'Qeb8u59Bd3', 'daniels2001@gmail.com', '(20) 3339 2739', 'r', 'Anthony Daniels', 'cSeECSEyVP');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (40, '2013-10-18 19:16:38', '2018-10-20 00:52:02', 'cR6HhF4ufl', 'rfsZ5ANZs2', 'nakayama1@mail.com', '213-069-7585', 'b', 'Nakayama Mio', 'ltTgQqI7qj');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (41, '2020-06-20 07:27:19', '2024-05-13 05:21:14', '8QET9G5reS', 'upTq0RR17Z', 'tmi2008@outlook.com', '838-615-0381', 'b', 'Takahashi Miu', 'lABy2AYEPt');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (42, '2016-12-23 00:12:40', '2019-01-26 19:19:13', '2m5d7HDyRf', 'N8djE8t0EP', 'stewarthaz@gmail.com', '190-3689-4686', 'c', 'Hazel Stewart', 'N8Llf7xMKN');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (43, '2001-10-24 12:11:03', '2001-03-18 09:33:05', '1b5hy26pcX', 'ZxdAF8Q0VC', 'daisukeshimada1027@mail.com', '7827 866515', 'r', 'Shimada Daisuke', 'pNHjzxp2Si');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (44, '2000-09-14 01:58:07', '2006-03-15 10:50:50', '4HsdTiyQjL', '33GvWsRL1U', 'onkalo@outlook.com', '718-812-5833', 'c', 'Lo On Kay', '2SIeKARWJv');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (45, '2008-02-03 00:55:42', '2007-09-13 07:46:32', 'JTlFikCRrW', 'fNifLpZg1s', 'aeita507@icloud.com', '3-8308-7783', 'r', 'Arai Eita', 'Na10MA394t');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (46, '2022-01-14 16:56:43', '2000-04-06 02:56:34', 'Doi2YeFcXU', 'bDa1x9KBTk', 'gadanielle@icloud.com', '70-7784-8164', 'c', 'Danielle Garza', 'ruj1BnFTfs');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (47, '2007-10-12 07:36:47', '2012-05-24 08:11:59', 'dVS2JDUU3n', 'D0rrfazScq', 'king1210@mail.com', '52-371-6070', 'r', 'Lori King', 'g51nUqhBoI');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (48, '2004-02-26 00:28:53', '2016-03-28 01:03:18', 'v4XWT4p0KE', 'xCSNxl2Tfz', 'maiog419@outlook.com', '132-5823-4439', 'c', 'Ogawa Mai', '5rj7q5zJbs');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (49, '2019-03-27 08:46:44', '2002-10-02 13:52:44', 'LwPfT2AUsK', 'J8c6GGpo2b', 'yamm@outlook.com', '198-0805-8892', 'b', 'Yam Ming', '7lXe11IovL');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (50, '2021-10-04 11:19:27', '2021-09-09 09:33:22', 'Yei4Wjn8Vk', 'BWfN4pg63j', 'liang1201@hotmail.com', '330-126-8250', 'c', 'Liang Yunxi', 'ALQR1qjGlP');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (51, '2008-07-29 23:33:02', '2005-08-18 13:26:32', '7FuzJSWgW7', 'QpxXK45Ulg', 'shimizum@hotmail.com', '(151) 566 6704', 'b', 'Shimizu Minato', 'HQ2HNkd4cu');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (52, '2024-11-07 05:30:34', '2021-06-13 01:46:10', 'WAI4KwheXz', 'cHlNGRSNeh', 'jialun6@icloud.com', '312-184-0042', 'c', 'Xiong Jialun', '0FOtV5HfUI');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (53, '2025-03-17 12:53:53', '2008-11-23 03:18:23', '136ayUssmw', 'n5it8IVOg8', 'miyazaki3@icloud.com', '213-651-7485', 'b', 'Miyazaki Eita', 'yRwO2jqWRO');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (54, '2016-10-20 05:57:43', '2019-02-07 11:55:08', 'p82HAdYAyj', 'l8LwtNxV0I', 'shinoyamada122@icloud.com', '212-806-1499', 'c', 'Yamada Shino', 'ccyC2RUlXE');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (55, '2024-09-01 13:48:58', '2009-10-14 22:04:32', 'TBkk0wa1mx', '37JVqxdt9Y', 'yutofu@outlook.com', '760-3996-1495', 'r', 'Fujii Yuto', '6Cgbvmpmi6');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (56, '2009-09-30 19:43:03', '2011-07-10 03:48:23', '723yv7Uu4W', 'DSB2D9WMOj', 'zzhu@yahoo.com', '330-487-0732', 'r', 'Zhu Zhennan', 'oKyiJ2gdWx');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (57, '2021-06-14 09:52:14', '2020-11-29 11:15:38', 'JooGUM1lFk', 'gl7U4bbUgN', 'justmurphy@hotmail.com', '80-6618-2062', 'b', 'Justin Murphy', 'ES0osxfAHs');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (58, '2015-09-14 15:11:01', '2015-09-14 11:19:22', 'QQBeZNbD2t', 'T68jDVvsQx', 'hawkinsf@icloud.com', '755-6709-5451', 'r', 'Florence Hawkins', 'p39DmsgLGi');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (59, '2018-04-12 09:41:41', '2003-07-03 23:52:09', 'VgTE1gSEs6', '0OMC9Z4k7X', 'ramirez5@outlook.com', '164-6209-2550', 'b', 'Nancy Ramirez', 'zaLL6sVtA9');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (60, '2005-01-11 20:06:32', '2005-07-20 02:39:38', 'IfMVXtmSVx', 'CTSszo9abP', 'wingsuenchic3@mail.com', '718-752-5747', 'b', 'Chic Wing Suen', 'LmDtPnfo8y');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (61, '2020-06-02 22:16:58', '2001-06-22 02:38:11', 'UKxl4HACKc', '7OPVbQe4rq', 'marshall1104@icloud.com', '(151) 021 7834', 'r', 'Ronald Marshall', 'Kz3ZCZ8AVq');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (62, '2007-11-26 16:02:12', '2012-06-10 00:05:41', 'XmYglDH2fL', 'n7CEo0AtAp', 'campbell607@gmail.com', '614-059-5592', 'b', 'Jamie Campbell', 'yOsvcxYQao');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (63, '2014-11-13 02:41:40', '2003-12-18 09:06:27', 'tZOSUzSlOL', 'eqq7lsXXFL', 'lufeng@icloud.com', '28-9560-4927', 'c', 'Feng Lu', 'WVnPuoORBO');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (64, '2001-05-17 04:51:15', '2004-04-13 21:58:31', '4Fjx8iKemU', 'X2OzKKGl3f', 'anqig@yahoo.com', '614-106-4445', 'b', 'Gong Anqi', 'wMHYMTPEtK');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (65, '2020-11-09 14:27:44', '2019-09-14 00:06:47', 'D9XqORRvYG', 'Lp9VEGG6cB', 'ryotayokoyama@gmail.com', '(20) 2664 2325', 'c', 'Yokoyama Ryota', 'IN8E5PVtHU');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (66, '2003-04-17 21:23:24', '2006-07-27 19:46:00', 'S5RlTaSfVh', 'H8jrcxQABD', 'hdaichi1959@gmail.com', '52-247-1442', 'r', 'Hayashi Daichi', 'nIRiOqPbd9');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (67, '2013-01-26 17:52:55', '2024-04-27 07:08:48', 'L7Fme4e9qA', 'HNDdwDspQx', 'tdouglas805@hotmail.com', '70-2056-8281', 'b', 'Douglas Tucker', 's43WYgAOQE');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (68, '2012-07-19 11:14:19', '2022-02-13 17:34:40', 'NSR6W0kKcP', 't8lPIWPMLe', 'yfsit@icloud.com', '148-3940-2035', 'c', 'Sit Yun Fat', 'EZNrkCWcpj');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (69, '2006-03-29 03:46:57', '2024-12-13 10:46:26', 'MYlJZ6Mkwn', 'ZRnZ4ThTui', 'firene@outlook.com', '144-1409-1190', 'c', 'Irene Ferguson', 'r7uAf72Qyh');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (70, '2011-02-28 15:16:43', '2015-01-04 22:28:42', '1ERnF1B476', 'avm1Nwecgv', 'nakts@hotmail.com', '5675 413985', 'c', 'Nakano Tsubasa', 'DpNpFEBRXZ');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (71, '2023-04-05 17:49:24', '2024-04-02 04:27:11', 'cYw262dowY', 'R4UI1Od8P0', 'ellis@icloud.com', '147-4155-9695', 'b', 'Stephen Ellis', '6dSQan8GwT');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (72, '2018-06-05 20:11:03', '2004-11-23 21:02:10', 'nVfmZwr4lg', 'YufgDCA7eM', 'sukyeeyuen8@gmail.com', '196-1816-6301', 'r', 'Yuen Suk Yee', 'oryRtIC0aa');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (73, '2018-02-17 03:12:44', '2012-05-14 02:46:16', 'J4QlhBCS0F', 'azxb4go5hH', 'shehly@outlook.com', '167-5082-4334', 'r', 'Sheh Lai Yan', 'UP6UdhIr0u');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (74, '2013-05-15 15:51:09', '2025-01-30 08:37:41', 'VzFOVe5MHs', 'YXDCOVqGvs', 'lijialun@yahoo.com', '156-9431-9071', 'b', 'Lin Jialun', 'WfvwOqFC2y');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (75, '2020-09-20 03:58:26', '2017-07-13 20:45:06', 'f0XSCidyEF', 'ivnpIqTbJV', 'momokwa@hotmail.com', '156-6312-9612', 'c', 'Wada Momoka', '3eqYa3g4tN');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (76, '2001-01-01 10:14:24', '2021-02-21 03:38:38', 'DXzUJvqVzq', 'xnS7lZVGoM', 'onlok@gmail.com', '755-9559-0555', 'r', 'Lok On Na', 'RaqjrOLx8H');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (77, '2007-06-27 07:41:52', '2011-05-29 19:20:24', 'pgKRGW1y9l', 'iyt8D2gBhP', 'fushingchan@gmail.com', '7096 839143', 'r', 'Chan Fu Shing', 'v1IsA6XNXH');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (78, '2023-12-14 16:23:09', '2006-07-26 00:25:55', 'YU1jav6OZI', 'GtCCDPJYah', 'inosar@outlook.com', '80-1151-9470', 'c', 'Inoue Sara', 'xSxBh6uhhj');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (79, '2015-05-12 12:09:13', '2011-10-20 19:28:25', 'UX7fZGYUDI', 'BYoOkUbGLY', 'chen210@mail.com', '(121) 716 2541', 'r', 'Chen Ziyi', 'CU2axwZ3wT');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (80, '2002-10-31 07:53:29', '2015-08-11 23:50:14', 'Lw7NKgoyN6', 'c20z7kX8X1', 'shihanfan@gmail.com', '(161) 175 7329', 'c', 'Fang Shihan', '1ok9pFFMcw');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (81, '2000-09-11 18:54:34', '2015-11-12 03:54:13', 'k1rIdFp7E8', 'FobtHYtlzf', 'pricean@gmail.com', '212-449-4205', 'c', 'Anita Price', 'xLDz9jQydW');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (82, '2016-06-25 10:15:58', '2009-04-24 13:02:38', 'hPhu6P907q', '4qHIIrTn9h', 'rubyphillips@hotmail.com', '838-454-0474', 'c', 'Ruby Phillips', 'oa2czTZ3yT');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (83, '2014-09-30 12:48:56', '2010-11-14 19:51:53', 'LDmsezDXCv', 'F7elau1V3R', 'jimenez521@gmail.com', '70-3672-1894', 'b', 'Michelle Jimenez', 'YAYSpUvV7k');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (84, '2016-01-25 07:02:06', '2023-08-04 12:16:29', 'loLzkvhedR', 'XOCL4CdrCF', 'otsus@yahoo.com', '7438 146912', 'b', 'Otsuka Sara', 'Df2Pm2jFkQ');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (85, '2009-07-29 15:14:32', '2020-04-11 22:58:17', 'TgyXIHFNsd', 'DhDIyVeTvk', 'fostemargaret@outlook.com', '90-6553-0728', 'c', 'Margaret Foster', 'DQDlPfNQpM');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (86, '2015-01-23 23:14:33', '2016-07-21 16:28:18', 'vxYcBWWTHQ', '4vsJnuN4qH', 'alexa@icloud.com', '176-4312-7321', 'r', 'Annie Alexander', 'Q1RxNxghAb');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (87, '2015-06-06 12:59:29', '2007-01-19 14:57:19', 'mXWgvLbrzI', '6TQ4qC0yOS', 'yamato7@gmail.com', '718-106-0921', 'b', 'Fujiwara Yamato', 'xCSk4nat4A');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (88, '2024-07-09 22:52:55', '2004-02-20 13:36:41', '1hO1XFCEur', 'ixHK2C73tD', 'yuensw@gmail.com', '(121) 735 2122', 'r', 'Yuen Sai Wing', 'DnGxvb8xL4');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (89, '2024-08-27 04:47:52', '2014-07-13 06:48:02', 'jdjsXs3j5d', 'nxOTktjEfD', 'andoyuito05@gmail.com', '70-2496-4600', 'c', 'Ando Yuito', 'Y8ZFLbwb5L');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (90, '2023-07-23 14:53:49', '2008-06-17 05:25:14', 'm6SqiuDpHQ', 'FeF0VtMwCd', 'waihanhung@gmail.com', '838-226-3701', 'r', 'Hung Wai Han', 'crkOhTTweD');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (91, '2007-12-01 00:12:15', '2003-05-08 03:50:47', 'rGnh6TH4sZ', 'oS1uTYcmBq', 'tszchf@icloud.com', '718-903-5311', 'c', 'Fan Tsz Ching', 'pcLdKjACxb');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (92, '2014-08-24 05:08:49', '2020-05-16 15:15:27', 'TiBkNBvkvZ', 'h5JrBM8U22', 'itoren@icloud.com', '718-876-2869', 'b', 'Ito Ren', 'E6xknkaAPu');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (93, '2001-05-19 13:25:05', '2014-01-08 18:44:18', 'try2ZUdpjS', 'niE0LwV469', 'miyazakishino@mail.com', '7260 904650', 'b', 'Miyazaki Shino', 'yX0bhTwhsr');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (94, '2002-06-03 21:53:39', '2019-05-17 11:30:44', 'gAZOk4W434', 'wHARutgOIx', 'muchungyin50@mail.com', '330-811-8409', 'r', 'Mui Chung Yin', 'mNSc0Ux5rv');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (95, '2005-06-11 17:43:50', '2008-11-07 10:11:33', 'BflfzaAGmQ', 'qlEcSBlXN7', 'arthurgo1954@gmail.com', '(121) 738 2907', 'r', 'Arthur Gomez', 'sV7SPdWP2A');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (96, '2001-06-26 10:47:03', '2000-09-07 21:43:07', '62i2bSA52z', 'a2FwK7oZJ9', 'jiehongzen@mail.com', '90-8853-6985', 'r', 'Zeng Jiehong', 'Fxy64IqQwY');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (97, '2002-07-27 07:22:57', '2015-09-05 23:33:11', 'voHge9YEIB', 'fSUyFhXScS', 'waimanf2@gmail.com', '190-3592-5236', 'c', 'Fong Wai Man', 'lwxBYh60ht');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (98, '2002-10-22 16:24:03', '2012-12-31 19:40:41', 'jNDwT9umyf', 'fGe2derz8m', 'lolingling@outlook.com', '7690 954441', 'b', 'Lo Ling Ling', 'PjhQjj9C3t');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (99, '2014-11-13 18:07:14', '2007-12-20 22:43:42', 'TMhQU9v093', 'jnwJkaxy9u', 'ps131@outlook.com', '52-179-8159', 'b', 'Phyllis Spencer', 'P1zpsDQKWO');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (100, '2001-07-19 22:14:29', '2018-11-23 00:27:40', '7lcqjVs2wX', 'tF9mW0rekz', 'sulu8@icloud.com', '213-513-9162', 'r', 'Su Lu', 'ZIxYsBqIW3');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (101, '2000-11-10 04:12:48', '2020-03-18 16:50:10', 'XhAVrfZMvS', 'J6R38ajFL8', 'lotinwing@gmail.com', '838-379-8168', 'c', 'Lok Tin Wing', 'NL3Vgzu3HZ');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (102, '2019-01-01 20:05:54', '2021-01-10 16:42:02', '65npGmdK8r', '2esDL6x42e', 'young930@yahoo.com', '7242 286879', 'c', 'Marjorie Young', 'bGDiv7XLNt');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (103, '2002-05-24 06:20:40', '2010-10-17 16:09:31', 'kVeiDZcBrU', 'AuG64u5vlW', 'lokchiuwai@gmail.com', '80-1032-0178', 'c', 'Lok Chiu Wai', 'jRmukSJ7sG');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (104, '2022-05-06 13:39:49', '2013-10-02 22:26:52', 'L9K5toaAsz', 'PIRLq9ennQ', 'lkw77@hotmail.com', '614-190-7765', 'c', 'Lam Kwok Wing', 'dj3ttuxQhS');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (105, '2003-09-28 16:41:26', '2018-01-14 19:01:00', '0bfff5XwTp', 'zFO1oxbdil', 'stanley108@icloud.com', '769-4957-1610', 'r', 'Stanley Gibson', 'AEpj8sJqqA');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (106, '2018-11-29 23:09:40', '2024-03-17 11:04:31', '9ffZySXEwK', 'uMNJg9yhVz', 'jawe@gmail.com', '168-0801-6729', 'r', 'Janet Weaver', 'rWfJEdveN7');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (107, '2013-08-17 14:43:32', '2019-10-15 05:50:46', '2V2VKQgewa', 'UYjIpkAgU8', 'nakagawa40@icloud.com', '769-779-7320', 'r', 'Nakagawa Ayato', 'RhEpG9zScC');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (108, '2009-03-12 23:59:09', '2007-07-31 19:59:44', 'nMsDjZ7PdQ', 'DH5d9ssNxc', 'graceshaw@gmail.com', '213-152-0712', 'r', 'Grace Shaw', 'BhX9xoqp26');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (109, '2018-06-14 22:09:53', '2009-03-20 11:44:39', 'F4t63sY4TX', '4wa8l7QSgx', 'hwayn2@icloud.com', '182-7551-5933', 'b', 'Wayne Hernandez', 'xeXt5v2XpQ');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (110, '2022-12-22 06:18:48', '2017-08-13 05:35:43', 'BqYxoGFXoA', 'ChXbyXqLYU', 'mm806@outlook.com', '21-0862-2503', 'c', 'Mary Moore', 'upiNm1R7RI');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (111, '2017-11-16 02:24:07', '2018-06-05 12:22:18', 'bviIb2tpiX', 'X3fzMZN6ir', 'sachin@gmail.com', '80-6173-6216', 'c', 'Chin Sai Wing', 'ZGbC6gE9Sc');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (112, '2014-05-22 03:58:45', '2003-10-13 22:17:18', '7ULlvdpR58', 'AwJQ9biQb7', 'siuwailee55@outlook.com', '212-394-8344', 'b', 'Lee Siu Wai', 'AEx5LPRE6l');
INSERT INTO `user` (`id`, `create_time`, `update_time`, `account`, `password`, `bind_email`, `bind_phone`, `role`, `name`, `avatar`) VALUES (113, '2025-06-08 12:16:34', '2025-06-08 12:16:34', 'axxx', 'axxxxx', 'axxx@a.com', '15664857737', 'b', 'axxx', '/boy.png');
COMMIT;

-- ----------------------------
-- Table structure for user_address
-- ----------------------------
DROP TABLE IF EXISTS `user_address`;
CREATE TABLE `user_address` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rela_user_id` int NOT NULL,
  `address` varchar(512) NOT NULL,
  `tag` varchar(64) NOT NULL,
  `position_x` double NOT NULL,
  `position_y` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user_address
-- ----------------------------
BEGIN;
INSERT INTO `user_address` (`id`, `create_time`, `update_time`, `rela_user_id`, `address`, `tag`, `position_x`, `position_y`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, '北京市朝阳区建国门外大街1号国贸大厦A座1001室', '公司', 116.458654, 39.917723);
INSERT INTO `user_address` (`id`, `create_time`, `update_time`, `rela_user_id`, `address`, `tag`, `position_x`, `position_y`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, '北京市朝阳区三里屯太古里南区S8-31', '家', 116.456621, 39.936049);
INSERT INTO `user_address` (`id`, `create_time`, `update_time`, `rela_user_id`, `address`, `tag`, `position_x`, `position_y`) VALUES (3, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, '北京市海淀区中关村大街27号中关村大厦15层', '公司', 116.315419, 39.983634);
INSERT INTO `user_address` (`id`, `create_time`, `update_time`, `rela_user_id`, `address`, `tag`, `position_x`, `position_y`) VALUES (4, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, '北京市海淀区学院路30号北京科技大学', '学校', 116.356253, 39.991957);
INSERT INTO `user_address` (`id`, `create_time`, `update_time`, `rela_user_id`, `address`, `tag`, `position_x`, `position_y`) VALUES (5, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, '北京市西城区西单北大街133号西单大悦城', '购物', 116.377048, 39.906901);
INSERT INTO `user_address` (`id`, `create_time`, `update_time`, `rela_user_id`, `address`, `tag`, `position_x`, `position_y`) VALUES (6, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, '北京市东城区王府井大街255号王府井百货', '购物', 116.417592, 39.917723);
COMMIT;

-- ----------------------------
-- Table structure for user_token
-- ----------------------------
DROP TABLE IF EXISTS `user_token`;
CREATE TABLE `user_token` (
  `id` int NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rela_user_id` int NOT NULL,
  `token` char(128) NOT NULL,
  `expired_time` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user_token
-- ----------------------------
BEGIN;
INSERT INTO `user_token` (`id`, `create_time`, `update_time`, `rela_user_id`, `token`, `expired_time`) VALUES (1, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 1, 'token_zhang_wei_2024_1749354951', '2025-06-15 11:55:51');
INSERT INTO `user_token` (`id`, `create_time`, `update_time`, `rela_user_id`, `token`, `expired_time`) VALUES (2, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 2, 'token_li_na_2024_1749354951', '2025-06-15 11:55:51');
INSERT INTO `user_token` (`id`, `create_time`, `update_time`, `rela_user_id`, `token`, `expired_time`) VALUES (3, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 3, 'token_wang_ming_2024_1749354951', '2025-06-15 11:55:51');
INSERT INTO `user_token` (`id`, `create_time`, `update_time`, `rela_user_id`, `token`, `expired_time`) VALUES (4, '2025-06-08 11:55:51', '2025-06-08 11:55:51', 4, 'token_liu_fang_2024_1749354951', '2025-06-15 11:55:51');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
